www.gusucode.com > 网页游戏五子棋onWeb 2008asp网站源码程序 > 网页游戏五子棋onWeb 2008asp网站源码程序/five/getRoomInfo.php

    <?php
include "./dbconnect.php";
$query = phpsql_query("select * from room");
$num = phpsql_num_rows($query);
for($i = 0;$i < $num;$i ++)
{
	$ID = phpsql_result($query, $i, ID);
	$player1_name = phpsql_result($query, $i, player1_name);
	$player2_name = phpsql_result($query, $i, player2_name);
	$player1_time = phpsql_result($query, $i, player1_time);
	$player2_time = phpsql_result($query, $i, player2_time);
	$player1_show = phpsql_result($query, $i, player1_show);
	$player2_show = phpsql_result($query, $i, player2_show);
	if($ori_time - $player1_time > 30)
	phpsql_query("update `room` set `flag` = '',`chess` = '',`player1_name` = '',`player1_time` = '0',`player1_win` = '0',`player1_show` = '' where `ID` = '".$ID."'");
	if($ori_time - $player2_time > 30)
	phpsql_query("update `room` set `flag` = '',`chess` = '',`player2_name` = '',`player2_time` = '0',`player2_win` = '0',`player2_show` = '' where `ID` = '".$ID."'");
	$system_time = phpsql_result($query, $i, system_time);
	$flag = phpsql_result($query, $i, flag);
	$roomInfo .= $ID."|".$player1_name."|".$player2_name."|".$flag."|".$player1_show."|".$player2_show."|;";
}
echo $roomInfo;
?>